| SyAddress |
| Logical Entity Name | SyAddress |
| Default Table Name | SyAddress |
| Physical Only | NO |
| Owner | dbo |
| Definition | |
| Note |
| SyAddress Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| SyStudentID | int | NO | ||
| AdEnrollID | int | NO | ||
| SyAddrTypeID | int | NO | ||
| LastName | varchar(128) | NO | ||
| FirstName | varchar(128) | NO | ||
| Addr1 | varchar(255) | NO | ||
| Addr2 | varchar(35) | NO | ||
| City | char(25) | NO | ||
| State | char(2) | NO | ||
| Zip | char(20) | NO | ||
| Country | varchar(50) | YES | ||
| Phone | char(16) | NO | ||
| YearsAtAddress | numeric(9, 1) | YES | ||
| RelationToStudent | varchar(30) | YES | ||
| YearsKnownStudent | numeric(9, 1) | YES | ||
| ReferenceConfirmed | char(1) | YES | ||
| DateReferenceConfirmed | datetime | YES | ||
| Employer | varchar(50) | YES | ||
| WorkPhone | char(16) | YES | ||
| Comments | text | YES | ||
| SSN | char(11) | YES | ||
| PrintedOnMasterPN | char(1) | YES | ||
| PrintedOnPlusPN | char(1) | YES | ||
| ClaimStudentAsDependent | char(1) | YES | ||
| ModFlag | char(1) | NO | ||
| Userid | int | NO | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
| ts | timestamp | NO | ||
SyAddressID |
int | NO | ||
| varchar(128) | YES | |||
| SecondPhone | char(16) | YES | ||
| SyCountryID | int | YES | ||
| syZoneID | int | YES | ||
| ReferenceNumber | int | NO | ||
| BeginDate | datetime | YES | ||
| EndDate | datetime | YES | ||
| Yearly | bit | NO | ||
| SyCountyID | int | YES | ||
AmTitleID |
int | YES | ||
| SourceSystem | char(1) | YES | ||
| PlusReferenceNumber | int | NO | ||
| CrmSuppressFlag | bit | NO | ||
| OtherPhone | nvarchar(20) | YES | ||
| OtherEmail | nvarchar(128) | YES | ||
| MobileNumber | nvarchar(16) | YES | ||
| ChangedVia | nvarchar(2) | YES | ||
| FullName | AS ((ltrim(rtrim([LastName]))+', ')+ltrim(rtrim(isnull([FirstName],'')))) |
| SyAddress Primary and Unique Keys |
| Key Name | Key Type | Keys |
| SyAddress_SyAddressID_U_C_IDX | PrimaryKey | SyAddressID |
| SyAddress Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| amTitle | Non-Identifying | Zero or One to Zero or More | FK_SyAddress_AmTitleID_AmTitle_AmTitleID | AmTitleID | NO | YES |
| Child Relationships: |
| SyAddress Check Constraints |
| Check Constraint Name | CheckConstraint |
| SyAddress Storage |
| STORAGE OPTION | STORAGE VALUE |
| Filegroup | PRIMARY |
| Text Image File Group | PRIMARY |
| SyAddress Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical dbo.StudentRelationshipAddress |
NO | |||
| Physical (Microsoft SQL Server) dbo.SyAddress |
NO |
| SyAddress Where Used - Submodel Usage |
| Model | Submodel Usage |
| Logical | Main Model |
| Logical | Addresses_Affiliations |
| Logical | FERPA |
| Logical | Refunds_Stipends |
| Logical | SubsidiaryLedger |
| Physical (Microsoft SQL Server) | Main Model |
| Physical (Microsoft SQL Server) | System |
| SyAddress Data Movement Rules |
| Name | Type | Rule Text/Value |